Tabela Institution

Definicja tabeli Institution

Name

Institution

Code

Institution

Comment

 


Lista kolumn tabeli Institution

Name

Code

InstitutionID

InstitutionID

CountryID

CountryID

InstitutionIdentifier

InstitutionIdentifier

Acronym

Acronym

FullName

FullName

StreetAndNr

StreetAndNr

Town

Town

ZipCode

ZipCode

CountryCode

CountryCode

Email

Email

Fax

Fax

Phone

Phone

Url

Url

Function1

Function1

Function2

Function2

OtherInstitution

OtherInstitution

OtherInstitutionID

OtherInstitutionID

StartDT

StartDT

StopDT

StopDT

ReasonForCharge

ReasonForCharge

Comments

Comments

NewInstitutionIdentification

NewInstitutionIdentification

Active

Active

InstitutionCWU

InstitutionCWU

DictionaryVersion

DictionaryVersion


Kolumna InstitutionID tabeli Institution

Definicja kolumny InstitutionID tabeli Institution

Name

InstitutionID

Code

InstitutionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CountryID tabeli Institution

Definicja kolumny CountryID tabeli Institution

Name

CountryID

Code

CountryID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InstitutionIdentifier tabeli Institution

Definicja kolumny InstitutionIdentifier tabeli Institution

Name

InstitutionIdentifier

Code

InstitutionIdentifier

Data Type

VARCHAR2(21)

Mandatory

No

Comment

 


Kolumna Acronym tabeli Institution

Definicja kolumny Acronym tabeli Institution

Name

Acronym

Code

Acronym

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna FullName tabeli Institution

Definicja kolumny FullName tabeli Institution

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna StreetAndNr tabeli Institution

Definicja kolumny StreetAndNr tabeli Institution

Name

StreetAndNr

Code

StreetAndNr

Data Type

VARCHAR2(90)

Mandatory

No

Comment

 


Kolumna Town tabeli Institution

Definicja kolumny Town tabeli Institution

Name

Town

Code

Town

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna ZipCode tabeli Institution

Definicja kolumny ZipCode tabeli Institution

Name

ZipCode

Code

ZipCode

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna CountryCode tabeli Institution

Definicja kolumny CountryCode tabeli Institution

Name

CountryCode

Code

CountryCode

Data Type

VARCHAR2(13)

Mandatory

No

Comment

 


Kolumna Email tabeli Institution

Definicja kolumny Email tabeli Institution

Name

Email

Code

Email

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna Fax tabeli Institution

Definicja kolumny Fax tabeli Institution

Name

Fax

Code

Fax

Data Type

VARCHAR2(84)

Mandatory

No

Comment

PL: Numer faxu
EN: Fax number
DE: Die Nummer des Fax


Kolumna Phone tabeli Institution

Definicja kolumny Phone tabeli Institution

Name

Phone

Code

Phone

Data Type

VARCHAR2(30)

Mandatory

No

Comment

PL: Numer telefonu
EN: Telephone number
DE: Die Telefonnummer


Kolumna Url tabeli Institution

Definicja kolumny Url tabeli Institution

Name

Url

Code

Url

Data Type

VARCHAR2(120)

Mandatory

No

Comment

 


Kolumna Function1 tabeli Institution

Definicja kolumny Function1 tabeli Institution

Name

Function1

Code

Function1

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna Function2 tabeli Institution

Definicja kolumny Function2 tabeli Institution

Name

Function2

Code

Function2

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna OtherInstitution tabeli Institution

Definicja kolumny OtherInstitution tabeli Institution

Name

OtherInstitution

Code

OtherInstitution

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna OtherInstitutionID tabeli Institution

Definicja kolumny OtherInstitutionID tabeli Institution

Name

OtherInstitutionID

Code

OtherInstitutionID

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Institution

Definicja kolumny StartDT tabeli Institution

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Institution

Definicja kolumny StopDT tabeli Institution

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna ReasonForCharge tabeli Institution

Definicja kolumny ReasonForCharge tabeli Institution

Name

ReasonForCharge

Code

ReasonForCharge

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna Comments tabeli Institution

Definicja kolumny Comments tabeli Institution

Name

Comments

Code

Comments

Data Type

VARCHAR2(265)

Mandatory

No

Comment

 


Kolumna NewInstitutionIdentification tabeli Institution

Definicja kolumny NewInstitutionIdentification tabeli Institution

Name

NewInstitutionIdentification

Code

NewInstitutionIdentification

Data Type

VARCHAR2(21)

Mandatory

No

Comment

 


Kolumna Active tabeli Institution

Definicja kolumny Active tabeli Institution

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna InstitutionCWU tabeli Institution

Definicja kolumny InstitutionCWU tabeli Institution

Name

InstitutionCWU

Code

InstitutionCWU

Data Type

VARCHAR2(40)

Mandatory

No

Comment

Identyfikator instytucji wlasciwej w slowniku CWU


Kolumna DictionaryVersion tabeli Institution

Definicja kolumny DictionaryVersion tabeli Institution

Name

DictionaryVersion

Code

DictionaryVersion

Data Type

VARCHAR2(20)

Mandatory

No

Comment

Numer wersji slownika w której wpis zostal dodany/zmieniony


Lista kluczy tabeli Institution

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Institution

Definicja klucza Identifier_1 tabeli Institution

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment